USE test
GO

CREATE TABLE dbo.[User](id INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
	    name VARCHAR(50) NOT NULL,
	    jointime DateTime NOT NULL,
	    account VARCHAR(50) NOT NULL,
	    pwd VARBINARY(4000) NOT NULL)
GO

CREATE INDEX IX_User_account ON dbo.[User](account)
GO